﻿CREATE PROCEDURE [dbo].[GetCategories]
@ProjectID INT
AS
SELECT	b.CategoryID,
		c.Name,
		c.Abbreviation,
		b.Duration
FROM	ProjectCategories b
		INNER JOIN Categories c ON b.CategoryID = c.CategoryID
WHERE	b.ProjectID = @ProjectID AND c.IsActive = 1

